php forum
php mysql forum
php mysql smarty
 
Page 1 of 2 1 2 >
Topic Options
#318555 - 04/03/10 11:35 PM [7.4+] RSS Topic Creator v1.1
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
Author: Gizmo (James of VNC Web Design)

Requirements:
Valid UBB.Threads 7.4 install and license

This will ONLY work with UBB.threads versions 7.4 and above.


About:
This mod will import RSS feeds as new topics. You can specify which forums the topics are posted to, and who posts them.

Installation instructions are included in the attached archive. Upload the files following the structure created in the archive.

Demo:
You can see this script in action on: My Dev Site and UGN Security.

File History
2600 - Initial 7.4+ cleanup.

Known Bugs
  • Will, at times, create duplicate topics; at times these are editorial revisions on some sites (Reuters for example) however.


NOTE
This mod is a port of an older UBB.threads7 mofification by Ian Spence which you can find here.


Attachments
RSS Topic Creator.zip (25 downloads)
Description: RSS Topic Creator v1.1


_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

Top
#318556 - 04/04/10 04:23 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Gizmo]
Vic Offline
Lurker

Registered: 03/26/10
Posts: 7
I have thanked you already but ile say it again thankyou lol.

I have just added a rss feed but i put the wrong member to show who has posted the feeds so i had to delete the feed posts on my forum and i have now re added another feed but now its not reposting what i have deleted.

Also when it posts it says

A TORY councillor who defected from Labour was today suspended from his new party after making a homophobic comment on his Facebook website.

Source: [url=http://www.wirralnews.co.uk/wirral-news/local-wirral-news/2010/03/31/wirral-councillor-suspended-for-anti-gay-facebook-update-100252-26144094/]Wirral councillor suspended for 'anti-gay' Facebook update[/ url]

Instead of putting a link.


Edited by Vic (04/04/10 04:35 PM)

Top
#318557 - 04/04/10 06:14 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Vic]
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
Well, that's expected behavior, it should try NOT to repost anything; there is a field in the database that holds the timestamp of the last time it "grabbed" the feed and it'll attempt not to repost anything before that timestamp.

You could try this query:
Code:
UPDATE `your_db`.`prefix_TOPIC_FEEDS` SET `LAST_BUILD` = '0', `LAST_TOPIC_TIME` = '0' WHERE  `prefix_TOPIC_FEEDS`.`FEED_ID` =1;


As for the link, on what you posted it has a space before the end tag at the end, is that what it's doing on your site? could you link me to a story?
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

Top
#318558 - 04/04/10 06:23 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Gizmo]
Vic Offline
Lurker

Registered: 03/26/10
Posts: 7
Originally Posted By: Gizmo
Well, that's expected behavior, it should try NOT to repost anything; there is a field in the database that holds the timestamp of the last time it "grabbed" the feed and it'll attempt not to repost anything before that timestamp.

You could try this query:
Code:
UPDATE `your_db`.`prefix_TOPIC_FEEDS` SET `LAST_BUILD` = '0', `LAST_TOPIC_TIME` = '0' WHERE  `prefix_TOPIC_FEEDS`.`FEED_ID` =1;


As for the link, on what you posted it has a space before the end tag at the end, is that what it's doing on your site? could you link me to a story?


No i had to leave a space or it would of posted correctly lol.
Its just posting on my website like that instead of the proper link.

Also just tried that code above and it says SQL Error: Table 'web180-forum-2.prefix_TOPIC_FEEDS' doesn't exist


Edited by Vic (04/04/10 06:27 PM)

Top
#318559 - 04/04/10 07:31 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Vic]
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
prefix_ needs to be changed to whatever your db prefix is
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

Top
#318560 - 04/04/10 08:02 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Gizmo]
Vic Offline
Lurker

Registered: 03/26/10
Posts: 7
Ok thanks.
The other problem as above is like i havnt got html activated for users on the forum but i have the feed isnt coming out as a link

Top
#318561 - 04/04/10 10:11 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Vic]
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
I need to see it... it should parse out regardless of your html setting... on my test forums the aggregator is a standard user account
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

Top
#318562 - 04/04/10 10:38 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Gizmo]
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
Be sure you have "Parse BBCode in feed" selected in the feed
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

Top
#318564 - 04/06/10 11:42 AM Re: [7.4+] RSS Topic Creator v1.1 [Re: Gizmo]
Vic Offline
Lurker

Registered: 03/26/10
Posts: 7
I have a problem.
Its not checking for more feeds every 15 minutes like i have set it. It updates once a day.

Top
#318565 - 04/06/10 01:37 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Vic]
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
Is the source feed updating more than once a day? I know a lot of sites cache out their feed in the early morning and only do it once a day...
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

Top
#318566 - 04/06/10 02:31 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Gizmo]
Vic Offline
Lurker

Registered: 03/26/10
Posts: 7
Originally Posted By: Gizmo
Is the source feed updating more than once a day? I know a lot of sites cache out their feed in the early morning and only do it once a day...


Its doing it once a day and thats it but when i look at the feed there is more news which could be added.
When i had Vbulletin it updated every 10 mins

(SORRY CAN THIS BE MOVED TO THE RSS FEED, I POSTED IN WRONG THREAD.)


Edited by Vic (04/06/10 04:43 PM)

Top
#318588 - 05/26/10 12:49 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Vic]
Robje Offline
Newbie

Registered: 01/24/08
Posts: 11
Loc: Netherlands - Valkenswaard
I don't receive any feeds. I added the lines in the source as described and added the files but nothing happens. Any idea how to check whether it is working right?

Top
#318702 - 03/11/11 08:04 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Gizmo]
AUS-CITY Offline
Newbie

Registered: 03/28/01
Posts: 16
Hi Gizmo,

I installed it, but its not making any new posts.

I am trying to post earthquake updates from USGS. the feed is live, so at 15 minutes I should be seeing posts, but nothing.

Its now started working smile

Is there a way it can post some of the data from the source, rather than a link just to it? The link is good at the bottom, but I want some of the data on the post rather than just a link.
_________________________
Webmaster
AUS-CITY Space and General Interest Forums
http://www.aus-city.com/ubbthreads/ubbthreads.php

Top
#318703 - 03/11/11 10:36 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Gizmo]
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
It's supposed to display data from the feed, could you provide me the URL so I can take a gander?
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

Top
#318704 - 03/11/11 10:51 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Gizmo]
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
Well, your problem from your feed is that they're using the description tag to roll out the date versus providing data on the page itself; the description tag is what gets parsed by this script.

They should be using the pubdate variable to publish the date, and the description variable to provide data on the link.
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

Top
#318705 - 03/11/11 11:01 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Gizmo]
AUS-CITY Offline
Newbie

Registered: 03/28/01
Posts: 16
Is it possible to tweak the scripts to parse the feed?

Also the atom feed just gets ignored..

http://earthquake.usgs.gov/earthquakes/catalogs/7day-M2.5.xml

Its got more info showing and a map, but nothing happens frown
_________________________
Webmaster
AUS-CITY Space and General Interest Forums
http://www.aus-city.com/ubbthreads/ubbthreads.php

Top
#318706 - 03/11/11 11:05 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: AUS-CITY]
AUS-CITY Offline
Newbie

Registered: 03/28/01
Posts: 16
Its NASA as well, all the feeds we need frown

http://www.aus-city.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=52828&gonew=1#UNREAD

Shows a date as the topic and info frown


It won't work with any feed from NASA:

http://www.nasa.gov/rss/

Also there is a bug. Any posts made by the fetching, keep the date of where the source is. This means twitter never picks them up as they are old as my forum is UTC+11.

The posts need to have the current time and date just like they were posted by a person.


Edited by AUS-CITY (03/11/11 11:30 PM)
_________________________
Webmaster
AUS-CITY Space and General Interest Forums
http://www.aus-city.com/ubbthreads/ubbthreads.php

Top
#318707 - 03/12/11 02:49 AM Re: [7.4+] RSS Topic Creator v1.1 [Re: Gizmo]
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
The RSS feed parses what it's supposed to; their feed displays data in a manner that isn't what the RSS spec says it should.

As for the ATOM feed, this script isn't designed to parse that at all... That's why it's politely ignored.

Basically it reads the title, description, and pubdate; description should hold data about the link, the title is the title of the story, and the pubdate should be the date associated with it.
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

Top
#318708 - 03/12/11 02:50 AM Re: [7.4+] RSS Topic Creator v1.1 [Re: Gizmo]
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
I'm not sure why the nasa rss feed is all on one line, kind of interesting...
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

Top
#318710 - 03/12/11 10:17 PM Re: [7.4+] RSS Topic Creator v1.1 [Re: Gizmo]
AUS-CITY Offline
Newbie

Registered: 03/28/01
Posts: 16
Can the topic creator me modified to accept ATOM feeds?

A lot of sites offer them.
_________________________
Webmaster
AUS-CITY Space and General Interest Forums
http://www.aus-city.com/ubbthreads/ubbthreads.php

Top
Page 1 of 2 1 2 >



Moderator:  sirdude 
Latest Posts
[7.2.1] - Naked shoutbox
by bellaonline
05/05/12 05:00 PM
[7.x] Stop Forum Spam Integration v0.4
by bellaonline
05/05/12 03:53 PM
Shout Box

(Views)Popular Topics
Known public proxy servers 1689885
Integrated Index Page (IIP) 5.3.1 555705
Finished-[6.5.2] Games Arcade Deluxe v1.9 501236
Integrated Index Page (IIP) 5.1.1 415112
TLD Bv2.1 Released - Threads Links Directory 396822
[6.0x] Who's Online 4.0.0 [Finished] 389412
Finished-[6.5.1] Integrated Index Page (IIP) 6.5 330423
Q & A 298663
Slash UBB 266936
[6.3.x] [beta] Hit Hack 2.0 227970
Forum Stats
13621 Members
59 Forums
37191 Topics
295716 Posts

Max Online: 686 @ 06/28/07 07:04 AM

 

 

 
fusionbb message board php hacks